Overview

Dataset info

Number of variables71
Number of observations1078349
Missing cells43891956 (57.3%)
Duplicate rows62095 (5.8%)
Total size in memory584.1 MiB
Average record size in memory568.0 B

Variables types

Numeric10
Categorical25
Boolean31
Date0
URL0
Text (Unique)0
Rejected2
Unsupported3

Warnings

Dataset has 62095 (5.8%) duplicate rows Warning
activitynumber has 118382 (11.0%) zeros Zeros
activitynumber has 506097 (46.9%) missing values Missing
activitywotype has 736387 (68.3%) missing values Missing
apptnumber has a high cardinality: 476000 distinct values Warning
atime_of_assignment has a high cardinality: 86501 distinct values Warning
atime_of_assignment has 220980 (20.5%) missing values Missing
atime_of_booking has a high cardinality: 300967 distinct values Warning
atime_of_booking has 22601 (2.1%) missing values Missing
barrio has a high cardinality: 75 distinct values Warning
ctime_delivered_end has a high cardinality: 7271 distinct values Warning
ctime_delivered_end has 1065531 (98.8%) missing values Missing
date only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
date has a high cardinality: 688 distinct values Warning
empresa_contratista has a high cardinality: 211 distinct values Warning
empresa_solicitante has a high cardinality: 142 distinct values Warning
estado_general has 413552 (38.4%) missing values Missing
fin_obra only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
fin_obra has a high cardinality: 903 distinct values Warning
gp_nuevo has 1055577 (97.9%) missing values Missing
inicio_obra only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
inicio_obra has a high cardinality: 878 distinct values Warning
latitude is highly skewed (γ1 = 54.70228489) Skewed
longitude is highly correlated with latitude (ρ = 0.9215028308) Rejected
mobileactacomproba is an unsupported type, check if it needs cleaning or further analysis Warning
mobileactaintima is an unsupported type, check if it needs cleaning or further analysis Warning
mobileactasecuestro is highly correlated with activitynumber (ρ = 0.9984427709) Rejected
mobilec01 has 1077398 (99.9%) missing values Missing
mobilec02 has 1077328 (99.9%) missing values Missing
mobilec03 has 1078292 (> 99.9%) missing values Missing
mobilec06 has 1062952 (98.6%) missing values Missing
mobilec07 has 1030722 (95.6%) missing values Missing
mobilec08 has 1052921 (97.6%) missing values Missing
mobilec09 has 1077426 (99.9%) missing values Missing
mobilec10 has 1061860 (98.5%) missing values Missing
mobilec11 has 1059402 (98.2%) missing values Missing
mobilec12 has 1024497 (95.0%) missing values Missing
mobilec13 has 1020505 (94.6%) missing values Missing
mobilec14 has 1024150 (95.0%) missing values Missing
mobilec15 has 1071867 (99.4%) missing values Missing
mobilec16 has 1073770 (99.6%) missing values Missing
mobilec17 has 1041473 (96.6%) missing values Missing
mobilec18 has 1076218 (99.8%) missing values Missing
mobilec20 has 1062097 (98.5%) missing values Missing
mobilec21 has 1051458 (97.5%) missing values Missing
mobilec22 has 1077981 (> 99.9%) missing values Missing
mobilec23 has 1068774 (99.1%) missing values Missing
mobilec24 has 1070994 (99.3%) missing values Missing
mobilec25 has 1040999 (96.5%) missing values Missing
mobilec26 has 1053278 (97.7%) missing values Missing
mobilec27 has 1078161 (> 99.9%) missing values Missing
mobilec28 has 1078206 (> 99.9%) missing values Missing
mobilec29 has 1077169 (99.9%) missing values Missing
mobilec30 has 1073920 (99.6%) missing values Missing
mobilec31 has 1073368 (99.5%) missing values Missing
mobilec32 has 1076972 (99.9%) missing values Missing
mobilec33 has 1076289 (99.8%) missing values Missing
mobilec34 has 1075658 (99.8%) missing values Missing
mobiledesnivel is an unsupported type, check if it needs cleaning or further analysis Warning
mobileseveridad has 1057405 (98.1%) missing values Missing
no_realizado has a high cardinality: 189 distinct values Warning
no_realizado has 658587 (61.1%) missing values Missing
obra_ancho is highly skewed (γ1 = 45.87975551) Skewed
obra_profundidad is highly skewed (γ1 = 41.11138068) Skewed
obra_superficie_m2 is highly skewed (γ1 = 80.83312449) Skewed
obra_volumen_m3 is highly skewed (γ1 = 106.1798117) Skewed
resource_name has a high cardinality: 393 distinct values Warning
severidad has 877266 (81.4%) missing values Missing
streetaddress has a high cardinality: 216053 distinct values Warning
traveltime has 434809 (40.3%) zeros Zeros
traveltime has 35148 (3.3%) missing values Missing

Variables

activity_status
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
complete
674364
cancelled
206516
suspended
 
133289
Other values (4)
 
64180
ValueCountFrequency (%) 
complete 674364 62.5%
 
cancelled 206516 19.2%
 
suspended 133289 12.4%
 
pending 48387 4.5%
 
deleted 15763 1.5%
 
started 28 < 0.1%
 
notdone 2 < 0.1%
 
Max length9
Mean length8.255599069
Min length7
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

activitynumber
Numeric

Distinct count1374
Unique (%)0.1%
Missing (%)46.9%
Missing (n)506097
Infinite (%)0.0%
Infinite (n)0
Mean21.15225111
Minimum0
Maximum1377
Zeros (%)11.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q13
Median14
Q327
95-th percentile45
Maximum1377
Range1377
Interquartile range24

Descriptive statistics

Standard deviation51.11215652
Coef of variation2.416393237
Kurtosis247.9084389
Mean21.15225111
MAD17.72783814
Skewness13.38171621
Sum12104418
Variance2612.452544
Memory size8.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 118382 11.0%
 
2 12209 1.1%
 
1 12161 1.1%
 
6 12153 1.1%
 
3 12128 1.1%
 
5 12118 1.1%
 
7 12089 1.1%
 
4 12086 1.1%
 
10 12065 1.1%
 
9 12041 1.1%
 
Other values (1363) 344820 32.0%
 
(Missing) 506097 46.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 118382 11.0%
 
1 12161 1.1%
 
2 12209 1.1%
 
3 12128 1.1%
 
4 12086 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1377 1 < 0.1%
 
1373 1 < 0.1%
 
1372 1 < 0.1%
 
1371 1 < 0.1%
 
1370 1 < 0.1%
 

activitytype
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
regular
1078345
reopened
 
4
ValueCountFrequency (%) 
regular 1078345 > 99.9%
 
reopened 4 < 0.1%
 
Max length8
Mean length7.000003709
Min length7
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

activitywotype
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)68.3%
Missing (n)736387
4
341962
(Missing)
736387
ValueCountFrequency (%) 
4 341962 31.7%
 
(Missing) 736387 68.3%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

aid
Numeric

Distinct count968605
Unique (%)89.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean646952.7044
Minimum362
Maximum1375807
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum362
5-th percentile72694.4
Q1301777
Median642904
Q3962830
95-th percentile1254587.4
Maximum1375807
Range1375445
Interquartile range661053

Descriptive statistics

Standard deviation382403.7259
Coef of variation0.5910845156
Kurtosis-1.222591575
Mean646952.7044
MAD336080.0432
Skewness0.0499061483
Sum6.976408018e+11
Variance1.462326096e+11
Memory size8.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[3.6200000e+02 3.8150000e+02 4.8250000e+02 6.3450000e+02 8.4750000e+02 ... 1.3748225e+06 1.3752335e+06 1.3753365e+06 1.3755440e+06 1.3758070e+06], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
736328 25 < 0.1%
 
929130 24 < 0.1%
 
929186 24 < 0.1%
 
947031 24 < 0.1%
 
937582 23 < 0.1%
 
883548 23 < 0.1%
 
953310 23 < 0.1%
 
960301 23 < 0.1%
 
966330 23 < 0.1%
 
976611 23 < 0.1%
 
Other values (968595) 1078114 > 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
362 1 < 0.1%
 
363 1 < 0.1%
 
364 1 < 0.1%
 
365 1 < 0.1%
 
367 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1375807 1 < 0.1%
 
1375806 1 < 0.1%
 
1375801 1 < 0.1%
 
1375798 1 < 0.1%
 
1375797 1 < 0.1%
 

apptnumber
Categorical

Distinct count476000
Unique (%)44.1%
Missing (%)0.0%
Missing (n)0
140008548511
 
69
140010675740
 
63
140010675730
 
63
Other values (475997)
1078154
ValueCountFrequency (%) 
140008548511 69 < 0.1%
 
140010675740 63 < 0.1%
 
140010675730 63 < 0.1%
 
140010675710 62 < 0.1%
 
140010675720 61 < 0.1%
 
140010675930 60 < 0.1%
 
140010675920 60 < 0.1%
 
140010675910 58 < 0.1%
 
140010675940 57 < 0.1%
 
140010675912 57 < 0.1%
 
Other values (475990) 1077739 99.9%
 
Max length19
Mean length12.01512868
Min length6
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

atime_of_assignment
Categorical

Distinct count86501
Unique (%)8.0%
Missing (%)20.5%
Missing (n)220980
2018-12-14T13:18:34Z
 
24245
2019-01-16T12:36:08Z
 
4296
2018-12-28T09:47:07Z
 
3576
Other values (86497)
825252
(Missing)
220980
ValueCountFrequency (%) 
2018-12-14T13:18:34Z 24245 2.2%
 
2019-01-16T12:36:08Z 4296 0.4%
 
2018-12-28T09:47:07Z 3576 0.3%
 
2018-12-28T12:01:46Z 3324 0.3%
 
2018-12-21T12:56:53Z 2836 0.3%
 
2018-01-03T12:26:43Z 2799 0.3%
 
2018-01-10T14:01:22Z 2662 0.2%
 
2018-01-16T14:32:07Z 2421 0.2%
 
2018-03-12T14:38:13Z 2412 0.2%
 
2018-04-17T12:15:32Z 2367 0.2%
 
Other values (86490) 806431 74.8%
 
(Missing) 220980 20.5%
 
Max length20
Mean length16.51628554
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

atime_of_booking
Categorical

Distinct count300967
Unique (%)27.9%
Missing (%)2.1%
Missing (n)22601
2019-02-07T12:48:33Z
 
1022
2019-01-28T12:35:37Z
 
856
2019-02-04T14:01:16Z
 
791
Other values (300963)
1053079
(Missing)
 
22601
ValueCountFrequency (%) 
2019-02-07T12:48:33Z 1022 0.1%
 
2019-01-28T12:35:37Z 856 0.1%
 
2019-02-04T14:01:16Z 791 0.1%
 
2019-01-31T13:34:02Z 768 0.1%
 
2019-01-30T12:01:46Z 746 0.1%
 
2018-12-05T12:59:49Z 740 0.1%
 
2019-01-29T12:22:09Z 729 0.1%
 
2019-02-05T13:53:47Z 700 0.1%
 
2019-02-01T13:19:03Z 635 0.1%
 
2019-02-01T12:26:02Z 612 0.1%
 
Other values (300956) 1048149 97.2%
 
(Missing) 22601 2.1%
 
Max length20
Mean length19.64369884
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

barrio
Categorical

Distinct count75
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)375
Palermo
 
69943
Flores
 
61586
Recoleta
 
41469
Other values (71)
904976
ValueCountFrequency (%) 
Palermo 69943 6.5%
 
Flores 61586 5.7%
 
Recoleta 41469 3.8%
 
Villa Urquiza 40955 3.8%
 
Caballito 39792 3.7%
 
Belgrano 39250 3.6%
 
Villa Devoto 38293 3.6%
 
Barracas 31983 3.0%
 
Nueva Pompeya 31088 2.9%
 
Liniers 30912 2.9%
 
Other values (64) 652703 60.5%
 
Max length17
Mean length10.31114602
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

clase_aviso
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)7
EM
621012
AP
358938
CG
 
98342
ValueCountFrequency (%) 
EM 621012 57.6%
 
AP 358938 33.3%
 
CG 98342 9.1%
 
SU 50 < 0.1%
 
(Missing) 7 < 0.1%
 
Max length3
Mean length2.000006491
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

comuna
Categorical

Distinct count17
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
C11
 
108009
C04
 
107623
C01
 
98462
Other values (13)
764254
ValueCountFrequency (%) 
C11 108009 10.0%
 
C04 107623 10.0%
 
C01 98462 9.1%
 
C07 87051 8.1%
 
C12 86105 8.0%
 
C10 81305 7.5%
 
C13 74306 6.9%
 
C15 73715 6.8%
 
C09 73424 6.8%
 
C14 70025 6.5%
 
Other values (6) 218323 20.2%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

ctime_delivered_end
Categorical

Distinct count7271
Unique (%)0.7%
Missing (%)98.8%
Missing (n)1065531
2019-02-05T10:38:38Z
 
21
2019-02-05T10:38:36Z
 
20
2019-01-28T07:52:10Z
 
19
Other values (7267)
 
12758
(Missing)
1065531
ValueCountFrequency (%) 
2019-02-05T10:38:38Z 21 < 0.1%
 
2019-02-05T10:38:36Z 20 < 0.1%
 
2019-01-28T07:52:10Z 19 < 0.1%
 
2019-01-31T07:02:00Z 18 < 0.1%
 
2019-01-29T07:44:23Z 16 < 0.1%
 
2019-02-05T10:38:31Z 15 < 0.1%
 
2019-01-25T07:32:11Z 14 < 0.1%
 
2019-02-05T10:38:37Z 14 < 0.1%
 
2019-02-05T10:38:32Z 14 < 0.1%
 
2019-02-05T10:38:33Z 13 < 0.1%
 
Other values (7260) 12654 1.2%
 
(Missing) 1065531 98.8%
 
Max length20
Mean length3.202073726
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

date
Categorical

Distinct count688
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
2018-12-17T00:00:00Z
 
31215
2018-04-03T00:00:00Z
 
13614
2018-12-08T00:00:00Z
 
8815
Other values (685)
1024705
ValueCountFrequency (%) 
2018-12-17T00:00:00Z 31215 2.9%
 
2018-04-03T00:00:00Z 13614 1.3%
 
2018-12-08T00:00:00Z 8815 0.8%
 
2018-01-22T00:00:00Z 8814 0.8%
 
2018-12-05T00:00:00Z 7428 0.7%
 
2019-01-17T00:00:00Z 7264 0.7%
 
2017-11-23T00:00:00Z 5355 0.5%
 
2018-12-30T00:00:00Z 4808 0.4%
 
2018-12-29T00:00:00Z 4612 0.4%
 
2018-11-17T00:00:00Z 4558 0.4%
 
Other values (678) 981866 91.1%
 
Max length20
Mean length20
Min length20
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

duracion
Numeric

Distinct count238
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean24.81843077
Minimum1
Maximum646
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile7
Q115
Median15
Q330
95-th percentile89
Maximum646
Range645
Interquartile range15

Descriptive statistics

Standard deviation24.74469892
Coef of variation0.9970291494
Kurtosis21.30823836
Mean24.81843077
MAD15.43543154
Skewness3.588861338
Sum26762930
Variance612.3001245
Memory size8.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 ... 333. 358.5 368. 476.5 646. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
15 535344 49.6%
 
30 95739 8.9%
 
7 35149 3.3%
 
12 29219 2.7%
 
10 25300 2.3%
 
90 24564 2.3%
 
18 23964 2.2%
 
32 23570 2.2%
 
8 21132 2.0%
 
31 18398 1.7%
 
Other values (228) 245970 22.8%
 

Minimum 5 values

ValueCountFrequency (%) 
1 590 0.1%
 
2 11085 1.0%
 
3 1013 0.1%
 
4 4358 0.4%
 
5 7668 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
646 4 < 0.1%
 
612 2 < 0.1%
 
545 4 < 0.1%
 
477 2 < 0.1%
 
476 6 < 0.1%
 

empresa_contratista
Categorical

Distinct count211
Unique (%)< 0.1%
Missing (%)0.1%
Missing (n)654
COSUGAS SRL
165561
EMA SERVICIOS S.A.
 
132351
AUTOTROL S.A.CONSTRUMAN S.A. UTE
 
82513
Other values (207)
697270
ValueCountFrequency (%) 
COSUGAS SRL 165561 15.4%
 
EMA SERVICIOS S.A. 132351 12.3%
 
AUTOTROL S.A.CONSTRUMAN S.A. UTE 82513 7.7%
 
AGUA Y SANEAMIENTOS ARGENTINOS SOCI 76277 7.1%
 
ARGENCOBRA S.A. 67193 6.2%
 
MANTELECTRIC I.C.I.S.A. 44347 4.1%
 
INARTECO S.A. 43683 4.1%
 
C Y E CONSTRUCCIONES SA 39739 3.7%
 
ZUBDESA S.A 34172 3.2%
 
POSE S.A 28538 2.6%
 
Other values (200) 363321 33.7%
 
Max length35
Mean length18.11381102
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

empresa_solicitante
Categorical

Distinct count142
Unique (%)< 0.1%
Missing (%)0.1%
Missing (n)837
AGUA Y SANEAMIENTOS ARGENTINOS SOCI
373787
EDESUR S.A.
142352
METROGAS S.A
101312
Other values (138)
460061
ValueCountFrequency (%) 
AGUA Y SANEAMIENTOS ARGENTINOS SOCI 373787 34.7%
 
EDESUR S.A. 142352 13.2%
 
METROGAS S.A 101312 9.4%
 
AUTOTROL S.A.CONSTRUMAN S.A. UTE 82513 7.7%
 
METROGAS S.A. 82359 7.6%
 
EDENOR SA 65922 6.1%
 
DIRECCION GRAL DE ALUMBRADO 39976 3.7%
 
AYSA S.A. 31971 3.0%
 
NSS S.A. 22024 2.0%
 
TELEFONICA DE ARGENTINA S.A. 21261 2.0%
 
Other values (131) 114035 10.6%
 
Max length35
Mean length23.04143278
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

estado_general
Categorical

Distinct count10
Unique (%)< 0.1%
Missing (%)38.4%
Missing (n)413552
A_DBE
304268
A_DME
134676
AC_NEA
122376
Other values (6)
103477
(Missing)
413552
ValueCountFrequency (%) 
A_DBE 304268 28.2%
 
A_DME 134676 12.5%
 
AC_NEA 122376 11.3%
 
AC_OEE 95576 8.9%
 
C_PBE 3164 0.3%
 
Nueva Apertura 2404 0.2%
 
C_PME 1307 0.1%
 
AC_OI 1023 0.1%
 
1 3 < 0.1%
 
(Missing) 413552 38.4%
 
Max length14
Mean length4.455159693
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

fin_obra
Categorical

Distinct count903
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
2018-12-12T00:00:00Z
 
8497
2019-02-11T00:00:00Z
 
7934
2018-12-20T00:00:00Z
 
7452
Other values (900)
1054466
ValueCountFrequency (%) 
2018-12-12T00:00:00Z 8497 0.8%
 
2019-02-11T00:00:00Z 7934 0.7%
 
2018-12-20T00:00:00Z 7452 0.7%
 
2018-11-26T00:00:00Z 6684 0.6%
 
2019-02-05T00:00:00Z 6507 0.6%
 
2018-12-17T00:00:00Z 6212 0.6%
 
2018-12-11T00:00:00Z 5544 0.5%
 
2017-12-05T00:00:00Z 5475 0.5%
 
2018-12-16T00:00:00Z 4702 0.4%
 
2018-12-10T00:00:00Z 4588 0.4%
 
Other values (893) 1014754 94.1%
 
Max length20
Mean length20
Min length20
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

gp_nuevo
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)97.9%
Missing (n)1055577
VE8
 
17115
CA1
 
5657
(Missing)
1055577
ValueCountFrequency (%) 
VE8 17115 1.6%
 
CA1 5657 0.5%
 
(Missing) 1055577 97.9%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

grupo_planificador
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
VE4
398504
VE5
371493
VE7
205383
Other values (2)
102968
ValueCountFrequency (%) 
VE4 398504 37.0%
 
VE5 371493 34.5%
 
VE7 205383 19.0%
 
VE6 102923 9.5%
 
CA1 45 < 0.1%
 
(Missing) 1 < 0.1%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

inicio_obra
Categorical

Distinct count878
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
2018-11-12T00:00:00Z
 
12882
2018-11-28T00:00:00Z
 
10755
2018-12-10T00:00:00Z
 
9547
Other values (875)
1045165
ValueCountFrequency (%) 
2018-11-12T00:00:00Z 12882 1.2%
 
2018-11-28T00:00:00Z 10755 1.0%
 
2018-12-10T00:00:00Z 9547 0.9%
 
2018-12-03T00:00:00Z 8777 0.8%
 
2019-01-28T00:00:00Z 6766 0.6%
 
2018-11-14T00:00:00Z 6376 0.6%
 
2018-11-27T00:00:00Z 6164 0.6%
 
2018-11-08T00:00:00Z 5906 0.5%
 
2019-01-21T00:00:00Z 5668 0.5%
 
2018-11-13T00:00:00Z 5594 0.5%
 
Other values (868) 999914 92.7%
 
Max length20
Mean length20
Min length20
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

latitude
Numeric

Distinct count14161
Unique (%)1.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean-34.60395863
Minimum-58.48939
Maximum0
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum-58.48939
5-th percentile-34.65957
Q1-34.6344
Median-34.6128
Q3-34.58983
95-th percentile-34.55743
Maximum0
Range58.48939
Interquartile range0.04457

Descriptive statistics

Standard deviation0.567509261
Coef of variation-0.01640012541
Kurtosis3588.076983
Mean-34.60395863
MAD0.035682058
Skewness54.70228489
Sum-37315144.18
Variance0.3220667613
Memory size8.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-58.48939 -58.47059 -58.46898 -58.44806 -34.70298 ... -34.535965 -34.5359 -34.5357 -17.267775 0. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-34.62861 3059 0.3%
 
-34.65655 904 0.1%
 
-34.64453 807 0.1%
 
-34.67462 687 0.1%
 
-34.62947 637 0.1%
 
-34.59639 627 0.1%
 
-34.60461 602 0.1%
 
-34.61769 551 0.1%
 
-34.67311 541 0.1%
 
-34.67278 532 < 0.1%
 
Other values (14151) 1069402 99.2%
 

Minimum 5 values

ValueCountFrequency (%) 
-58.48939 1 < 0.1%
 
-58.48777 1 < 0.1%
 
-58.47063 2 < 0.1%
 
-58.47055 1 < 0.1%
 
-58.47049 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
0 272 < 0.1%
 
-34.53555 15 < 0.1%
 
-34.53585 1 < 0.1%
 
-34.53595 50 < 0.1%
 
-34.53598 4 < 0.1%
 

longitude
Highly correlated

This variable is highly correlated with latitude and should be ignored for analysis

Correlation0.9215028308

mobileactacomproba
Unsupported

This variable is an unsupported type, check if it needs cleaning or further analysis

Unsupported value

mobileactaintima
Unsupported

This variable is an unsupported type, check if it needs cleaning or further analysis

Unsupported value

mobileactasecuestro
Highly correlated

This variable is highly correlated with activitynumber and should be ignored for analysis

Correlation0.9984427709

mobilec01
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)99.9%
Missing (n)1077398
1
 
951
(Missing)
1077398
ValueCountFrequency (%) 
1 951 0.1%
 
(Missing) 1077398 99.9%
 

mobilec02
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)99.9%
Missing (n)1077328
1
 
1021
(Missing)
1077328
ValueCountFrequency (%) 
1 1021 0.1%
 
(Missing) 1077328 99.9%
 

mobilec03
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1078292
1
 
57
(Missing)
1078292
ValueCountFrequency (%) 
1 57 < 0.1%
 
(Missing) 1078292 > 99.9%
 

mobilec06
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)98.6%
Missing (n)1062952
1
 
15397
(Missing)
1062952
ValueCountFrequency (%) 
1 15397 1.4%
 
(Missing) 1062952 98.6%
 

mobilec07
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)95.6%
Missing (n)1030722
1
 
47627
(Missing)
1030722
ValueCountFrequency (%) 
1 47627 4.4%
 
(Missing) 1030722 95.6%
 

mobilec08
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)97.6%
Missing (n)1052921
1
 
25428
(Missing)
1052921
ValueCountFrequency (%) 
1 25428 2.4%
 
(Missing) 1052921 97.6%
 

mobilec09
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)99.9%
Missing (n)1077426
1
 
923
(Missing)
1077426
ValueCountFrequency (%) 
1 923 0.1%
 
(Missing) 1077426 99.9%
 

mobilec10
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)98.5%
Missing (n)1061860
1
 
16489
(Missing)
1061860
ValueCountFrequency (%) 
1 16489 1.5%
 
(Missing) 1061860 98.5%
 

mobilec11
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)98.2%
Missing (n)1059402
1
 
18947
(Missing)
1059402
ValueCountFrequency (%) 
1 18947 1.8%
 
(Missing) 1059402 98.2%
 

mobilec12
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)95.0%
Missing (n)1024497
1
 
53852
(Missing)
1024497
ValueCountFrequency (%) 
1 53852 5.0%
 
(Missing) 1024497 95.0%
 

mobilec13
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)94.6%
Missing (n)1020505
1
 
57844
(Missing)
1020505
ValueCountFrequency (%) 
1 57844 5.4%
 
(Missing) 1020505 94.6%
 

mobilec14
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)95.0%
Missing (n)1024150
1
 
54199
(Missing)
1024150
ValueCountFrequency (%) 
1 54199 5.0%
 
(Missing) 1024150 95.0%
 

mobilec15
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)99.4%
Missing (n)1071867
1
 
6482
(Missing)
1071867
ValueCountFrequency (%) 
1 6482 0.6%
 
(Missing) 1071867 99.4%
 

mobilec16
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)99.6%
Missing (n)1073770
1
 
4579
(Missing)
1073770
ValueCountFrequency (%) 
1 4579 0.4%
 
(Missing) 1073770 99.6%
 

mobilec17
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)96.6%
Missing (n)1041473
1
 
36876
(Missing)
1041473
ValueCountFrequency (%) 
1 36876 3.4%
 
(Missing) 1041473 96.6%
 

mobilec18
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)99.8%
Missing (n)1076218
1
 
2131
(Missing)
1076218
ValueCountFrequency (%) 
1 2131 0.2%
 
(Missing) 1076218 99.8%
 

mobilec20
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)98.5%
Missing (n)1062097
1
 
16252
(Missing)
1062097
ValueCountFrequency (%) 
1 16252 1.5%
 
(Missing) 1062097 98.5%
 

mobilec21
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)97.5%
Missing (n)1051458
1
 
26891
(Missing)
1051458
ValueCountFrequency (%) 
1 26891 2.5%
 
(Missing) 1051458 97.5%
 

mobilec22
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1077981
1
 
368
(Missing)
1077981
ValueCountFrequency (%) 
1 368 < 0.1%
 
(Missing) 1077981 > 99.9%
 

mobilec23
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)99.1%
Missing (n)1068774
1
 
9575
(Missing)
1068774
ValueCountFrequency (%) 
1 9575 0.9%
 
(Missing) 1068774 99.1%
 

mobilec24
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)99.3%
Missing (n)1070994
1
 
7355
(Missing)
1070994
ValueCountFrequency (%) 
1 7355 0.7%
 
(Missing) 1070994 99.3%
 

mobilec25
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)96.5%
Missing (n)1040999
1
 
37350
(Missing)
1040999
ValueCountFrequency (%) 
1 37350 3.5%
 
(Missing) 1040999 96.5%
 

mobilec26
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)97.7%
Missing (n)1053278
1
 
25071
(Missing)
1053278
ValueCountFrequency (%) 
1 25071 2.3%
 
(Missing) 1053278 97.7%
 

mobilec27
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1078161
1
 
188
(Missing)
1078161
ValueCountFrequency (%) 
1 188 < 0.1%
 
(Missing) 1078161 > 99.9%
 

mobilec28
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)1078206
1
 
143
(Missing)
1078206
ValueCountFrequency (%) 
1 143 < 0.1%
 
(Missing) 1078206 > 99.9%
 

mobilec29
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)99.9%
Missing (n)1077169
1
 
1180
(Missing)
1077169
ValueCountFrequency (%) 
1 1180 0.1%
 
(Missing) 1077169 99.9%
 

mobilec30
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)99.6%
Missing (n)1073920
1
 
4429
(Missing)
1073920
ValueCountFrequency (%) 
1 4429 0.4%
 
(Missing) 1073920 99.6%
 

mobilec31
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)99.5%
Missing (n)1073368
1
 
4981
(Missing)
1073368
ValueCountFrequency (%) 
1 4981 0.5%
 
(Missing) 1073368 99.5%
 

mobilec32
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)99.9%
Missing (n)1076972
1
 
1377
(Missing)
1076972
ValueCountFrequency (%) 
1 1377 0.1%
 
(Missing) 1076972 99.9%
 

mobilec33
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)99.8%
Missing (n)1076289
1
 
2060
(Missing)
1076289
ValueCountFrequency (%) 
1 2060 0.2%
 
(Missing) 1076289 99.8%
 

mobilec34
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)99.8%
Missing (n)1075658
1
 
2691
(Missing)
1075658
ValueCountFrequency (%) 
1 2691 0.2%
 
(Missing) 1075658 99.8%
 

mobiledesnivel
Unsupported

This variable is an unsupported type, check if it needs cleaning or further analysis

Unsupported value

mobileseveridad
Categorical

Distinct count8
Unique (%)< 0.1%
Missing (%)98.1%
Missing (n)1057405
CMR
 
8246
GPA
 
5671
CPE
 
3737
Other values (4)
 
3290
(Missing)
1057405
ValueCountFrequency (%) 
CMR 8246 0.8%
 
GPA 5671 0.5%
 
CPE 3737 0.3%
 
ELA 1542 0.1%
 
EPB 916 0.1%
 
CAM 510 < 0.1%
 
CAB 322 < 0.1%
 
(Missing) 1057405 98.1%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

no_realizado
Categorical

Distinct count189
Unique (%)< 0.1%
Missing (%)61.1%
Missing (n)658587
otros
236843
vacio
 
74116
Otra tarea asignada
 
44683
Other values (185)
 
64120
(Missing)
658587
ValueCountFrequency (%) 
otros 236843 22.0%
 
vacio 74116 6.9%
 
Otra tarea asignada 44683 4.1%
 
condiciones_climaticas 18986 1.8%
 
zona_postergada 9323 0.9%
 
ninguno 7906 0.7%
 
Enfermedad 7230 0.7%
 
Problemas con celular 6544 0.6%
 
0 4084 0.4%
 
1 2244 0.2%
 
Other values (178) 7803 0.7%
 
(Missing) 658587 61.1%
 
Max length22
Mean length4.849763852
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

obra_ancho
Numeric

Distinct count364
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)9
Infinite (%)0.0%
Infinite (n)0
Mean0.8445371775
Minimum0
Maximum300
Zeros (%)0.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.4
Q10.6
Median0.6
Q31
95-th percentile1.2
Maximum300
Range300
Interquartile range0.4

Descriptive statistics

Standard deviation2.497631501
Coef of variation2.957396746
Kurtosis3155.598226
Mean0.8445371775
MAD0.3837972714
Skewness45.87975551
Sum910698.22
Variance6.238163114
Memory size8.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0.6 324562 30.1%
 
1 252859 23.4%
 
0.4 232935 21.6%
 
0.8 137616 12.8%
 
1.2 25766 2.4%
 
0.5 21856 2.0%
 
2 12882 1.2%
 
0.65 11270 1.0%
 
1.6 5958 0.6%
 
0.52 5598 0.5%
 
Other values (353) 47038 4.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2422 0.2%
 
0.04 3 < 0.1%
 
0.06 5 < 0.1%
 
0.1 106 < 0.1%
 
0.11 3 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
300 1 < 0.1%
 
289 5 < 0.1%
 
252 2 < 0.1%
 
250 3 < 0.1%
 
220 8 < 0.1%
 

obra_largo
Numeric

Distinct count1540
Unique (%)0.1%
Missing (%)< 0.1%
Missing (n)9
Infinite (%)0.0%
Infinite (n)0
Mean8.02670794
Minimum0
Maximum999
Zeros (%)0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.5
Q10.8
Median1.2
Q35
95-th percentile40
Maximum999
Range999
Interquartile range4.2

Descriptive statistics

Standard deviation22.03967638
Coef of variation2.745792739
Kurtosis250.791735
Mean8.02670794
MAD9.9764333
Skewness10.6377537
Sum8655520.24
Variance485.7473349
Memory size8.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0.6 198364 18.4%
 
1 148321 13.8%
 
1.2 83843 7.8%
 
2 72846 6.8%
 
10 59912 5.6%
 
0.8 55182 5.1%
 
4 45696 4.2%
 
0.4 43026 4.0%
 
3 35388 3.3%
 
5 34743 3.2%
 
Other values (1529) 301019 27.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1243 0.1%
 
0.06 8 < 0.1%
 
0.08 28 < 0.1%
 
0.1 81 < 0.1%
 
0.11 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
999 16 < 0.1%
 
900 5 < 0.1%
 
890 5 < 0.1%
 
885 4 < 0.1%
 
830 2 < 0.1%
 

obra_profundidad
Numeric

Distinct count139
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)9
Infinite (%)0.0%
Infinite (n)0
Mean0.8243085947
Minimum0
Maximum100
Zeros (%)0.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.4
Q10.6
Median0.8
Q31
95-th percentile1.3
Maximum100
Range100
Interquartile range0.4

Descriptive statistics

Standard deviation0.8497834085
Coef of variation1.030904462
Kurtosis2676.936877
Mean0.8243085947
MAD0.2685200977
Skewness41.11138068
Sum888884.93
Variance0.7221318413
Memory size8.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0.6 285472 26.5%
 
1 208455 19.3%
 
0.8 203257 18.8%
 
0.4 98972 9.2%
 
1.2 60282 5.6%
 
0.7 40722 3.8%
 
1.1 35893 3.3%
 
1.3 28250 2.6%
 
0.65 27116 2.5%
 
2 15874 1.5%
 
Other values (128) 74047 6.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 5085 0.5%
 
0.02 3 < 0.1%
 
0.04 27 < 0.1%
 
0.05 10 < 0.1%
 
0.08 16 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
100 2 < 0.1%
 
80 5 < 0.1%
 
75 10 < 0.1%
 
70 5 < 0.1%
 
65 1 < 0.1%
 

obra_superficie_m2
Numeric

Distinct count2425
Unique (%)0.2%
Missing (%)< 0.1%
Missing (n)9
Infinite (%)0.0%
Infinite (n)0
Mean8.836598141
Minimum0
Maximum23882.82
Zeros (%)0.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.25
Q10.48
Median1
Q34
95-th percentile22
Maximum23882.82
Range23882.82
Interquartile range3.52

Descriptive statistics

Standard deviation199.2474317
Coef of variation22.54797927
Kurtosis7560.372361
Mean8.836598141
MAD12.4355198
Skewness80.83312449
Sum9528857.239
Variance39699.53904
Memory size8.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0.36 163031 15.1%
 
1 129512 12.0%
 
4 63878 5.9%
 
1.2 39952 3.7%
 
2 37985 3.5%
 
0.8 36038 3.3%
 
0.96 36014 3.3%
 
0.72 32780 3.0%
 
0.48 30350 2.8%
 
0.64 28673 2.7%
 
Other values (2414) 480127 44.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2887 0.3%
 
0.0066 2 < 0.1%
 
0.01 69 < 0.1%
 
0.02 4 < 0.1%
 
0.0225 75 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
23882.82 10 < 0.1%
 
22500 2 < 0.1%
 
21228 31 < 0.1%
 
15330 5 < 0.1%
 
13596.4 39 < 0.1%
 

obra_volumen_m3
Numeric

Distinct count3401
Unique (%)0.3%
Missing (%)< 0.1%
Missing (n)9
Infinite (%)0.0%
Infinite (n)0
Mean29.12975427
Minimum0
Maximum358242.3
Zeros (%)0.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.128
Q10.384
Median1
Q33
95-th percentile17.28
Maximum358242.3
Range358242.3
Interquartile range2.616

Descriptive statistics

Standard deviation1990.947712
Coef of variation68.34756289
Kurtosis13095.34254
Mean29.12975427
MAD51.76345628
Skewness106.1798117
Sum31411779.22
Variance3963872.792
Memory size8.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0.216 117229 10.9%
 
1 115733 10.7%
 
0.432 53172 4.9%
 
0.64 33727 3.1%
 
4 23936 2.2%
 
2.6 23342 2.2%
 
0.72 22226 2.1%
 
1.92 18120 1.7%
 
0.96 17606 1.6%
 
0.275 16471 1.5%
 
Other values (3390) 636778 59.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 6739 0.6%
 
0.001 63 < 0.1%
 
0.004 1 < 0.1%
 
0.005 4 < 0.1%
 
0.0064 3 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
358242.3 7 < 0.1%
 
203946 39 < 0.1%
 
202629.51 6 < 0.1%
 
202552.2 2 < 0.1%
 
200000 3 < 0.1%
 

resource_name
Categorical

Distinct count393
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
VPA
 
92532
Vías Peatonales
 
48263
Aperturas
 
28232
Other values (390)
909322
ValueCountFrequency (%) 
VPA 92532 8.6%
 
Vías Peatonales 48263 4.5%
 
Aperturas 28232 2.6%
 
SCARANTE 8322 0.8%
 
ACADAVEIRA 7989 0.7%
 
MLEPEZ 7883 0.7%
 
SYANTORNO 7846 0.7%
 
SBUSTOS 7734 0.7%
 
AMANZETTI 7646 0.7%
 
Harilaos Belen 7023 0.7%
 
Other values (383) 854879 79.3%
 
Max length34
Mean length12.42721883
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

severidad
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)81.4%
Missing (n)877266
3
 
86376
2
 
80472
1
 
34235
(Missing)
877266
ValueCountFrequency (%) 
3 86376 8.0%
 
2 80472 7.5%
 
1 34235 3.2%
 
(Missing) 877266 81.4%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

status_usuario
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
PLAN
403482
REOK
255378
SERV
149166
Other values (2)
270323
ValueCountFrequency (%) 
PLAN 403482 37.4%
 
REOK 255378 23.7%
 
SERV 149166 13.8%
 
VERI 145893 13.5%
 
INEX 124430 11.5%
 
Max length4
Mean length4
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

streetaddress
Categorical

Distinct count216053
Unique (%)20.0%
Missing (%)0.1%
Missing (n)1544
ARTIGAS, JOSE GERVASIO, GRAL. 7, CABA
 
2983
PASAJE C y BENEDETTI, OSVALDO E., DIP.NAC., CABA
 
849
CONTINUACION AV. COREA (SIN NOMBRE OFICIAL) y BONORINO, ESTEBAN, CNEL. AV., CABA
 
653
Other values (216049)
1072320
(Missing)
 
1544
ValueCountFrequency (%) 
ARTIGAS, JOSE GERVASIO, GRAL. 7, CABA 2983 0.3%
 
PASAJE C y BENEDETTI, OSVALDO E., DIP.NAC., CABA 849 0.1%
 
CONTINUACION AV. COREA (SIN NOMBRE OFICIAL) y BONORINO, ESTEBAN, CNEL. AV., CABA 653 0.1%
 
LA RABIDA (S) AV. 6, CABA 345 < 0.1%
 
CARABELAS 235, CABA 320 < 0.1%
 
ACEVEDO 22, CABA 240 < 0.1%
 
DE LA ROSA, JOSE I., DR. 5841 194 < 0.1%
 
LA RABIDA (S) AV. 22, CABA 192 < 0.1%
 
LA RABIDA (S) AV. 5, CABA 191 < 0.1%
 
ALBERTI 601 182 < 0.1%
 
Other values (216042) 1070656 99.3%
 
(Missing) 1544 0.1%
 
Max length80
Mean length18.79977447
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

tipo_obra
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)2
ACERA
1050750
CALZADA
 
27597
(Missing)
 
2
ValueCountFrequency (%) 
ACERA 1050750 97.4%
 
CALZADA 27597 2.6%
 
(Missing) 2 < 0.1%
 
Max length7
Mean length5.051180091
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

traveltime
Numeric

Distinct count576
Unique (%)0.1%
Missing (%)3.3%
Missing (n)35148
Infinite (%)0.0%
Infinite (n)0
Mean5.283067213
Minimum0
Maximum812
Zeros (%)40.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q35
95-th percentile17
Maximum812
Range812
Interquartile range5

Descriptive statistics

Standard deviation19.8877427
Coef of variation3.764431133
Kurtosis250.2847915
Mean5.283067213
MAD6.480273072
Skewness13.24003729
Sum5511301
Variance395.5223096
Memory size8.2 MiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 434809 40.3%
 
1 140235 13.0%
 
2 76851 7.1%
 
3 64140 5.9%
 
5 59623 5.5%
 
4 52010 4.8%
 
10 32442 3.0%
 
6 32144 3.0%
 
7 24990 2.3%
 
8 19600 1.8%
 
Other values (565) 106357 9.9%
 
(Missing) 35148 3.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 434809 40.3%
 
1 140235 13.0%
 
2 76851 7.1%
 
3 64140 5.9%
 
4 52010 4.8%
 

Maximum 5 values

ValueCountFrequency (%) 
812 1 < 0.1%
 
790 1 < 0.1%
 
778 1 < 0.1%
 
750 1 < 0.1%
 
747 1 < 0.1%
 

Correlations

Missing values

Sample

First rows

activity_statusactivitynumberactivitytypeactivitywotypeaidapptnumberatime_of_assignmentatime_of_bookingbarrioclase_avisocomunactime_delivered_enddateduracionempresa_contratistaempresa_solicitanteestado_generalfin_obragp_nuevogrupo_planificadorinicio_obralatitudelongitudemobileactacomprobamobileactaintimamobileactasecuestromobilec01mobilec02mobilec03mobilec06mobilec07mobilec08mobilec09mobilec10mobilec11mobilec12mobilec13mobilec14mobilec15mobilec16mobilec17mobilec18mobilec20mobilec21mobilec22mobilec23mobilec24mobilec25mobilec26mobilec27mobilec28mobilec29mobilec30mobilec31mobilec32mobilec33mobilec34mobiledesnivelmobileseveridadno_realizadoobra_anchoobra_largoobra_profundidadobra_superficie_m2obra_volumen_m3resource_nameseveridadstatus_usuariostreetaddresstipo_obratraveltime
0cancelled0.0regular4.0120801150020503870NaN2017-10-13T11:27:35ZBelgranoEMC13NaN2017-10-27T00:00:00Z15FUENTES Y ASOCIADOS S.A.EDENOR SANaN2017-10-27T00:00:00ZNaNVE42017-10-13T00:00:00Z-34.54666-58.44965NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros0.210.00.42.000.800AperturasNaNPLANFIGUEROA ALCORTA, PRES. AV. 7601, CABAACERA0.0
1cancelled0.0regular4.0120825150020505420NaN2017-10-13T11:27:36ZVilla DevotoEMC11NaN2017-10-27T00:00:00Z15AGUA Y SANEAMIENTOS ARGENTINOS SOCIAGUA Y SANEAMIENTOS ARGENTINOS SOCINaN2017-10-27T00:00:00ZNaNVE42017-10-13T00:00:00Z-34.61127-58.52217NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros0.20.20.20.040.008AperturasNaNPLANNAVARRO 5072, CABAACERA0.0
2cancelled0.0regular4.0121443150020510714NaN2017-10-17T14:04:57ZMonte CastroEMC10NaN2017-10-27T00:00:00Z15AUTOTROL S.A.CONSTRUMAN S.A. UTEAUTOTROL S.A.CONSTRUMAN S.A. UTENaN2017-10-27T00:00:00ZNaNVE42017-10-13T00:00:00Z-34.61922-58.50749NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros0.60.61.20.360.432AperturasNaNPLANLASCANO 4817ACERA0.0
3cancelled0.0regular4.0121446150020510720NaN2017-10-17T14:04:58ZMonte CastroEMC10NaN2017-10-27T00:00:00Z15AUTOTROL S.A.CONSTRUMAN S.A. UTEAUTOTROL S.A.CONSTRUMAN S.A. UTENaN2017-10-27T00:00:00ZNaNVE42017-10-13T00:00:00Z-34.61922-58.50749NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros0.60.61.20.360.432AperturasNaNPLANLASCANO 4871ACERA0.0
4cancelled0.0regular4.0121449150020510710NaN2017-10-17T14:04:58ZMonte CastroEMC10NaN2017-10-27T00:00:00Z15AUTOTROL S.A.CONSTRUMAN S.A. UTEAUTOTROL S.A.CONSTRUMAN S.A. UTENaN2017-10-27T00:00:00ZNaNVE42017-10-13T00:00:00Z-34.61922-58.50749NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros0.60.61.20.360.432AperturasNaNPLANLASCANO 4895ACERA0.0
5cancelled0.0regular4.0121460150020511010NaN2017-10-17T14:04:58ZMonte CastroEMC10NaN2017-10-27T00:00:00Z15AUTOTROL S.A.CONSTRUMAN S.A. UTEAUTOTROL S.A.CONSTRUMAN S.A. UTENaN2017-10-27T00:00:00ZNaNVE42017-10-13T00:00:00Z-34.61866-58.50642NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros0.60.61.20.360.432AperturasNaNPLANLASCANO 4797ACERA0.0
6cancelled0.0regular4.0121463150020511114NaN2017-10-17T14:04:58ZMonte CastroEMC10NaN2017-10-27T00:00:00Z15AUTOTROL S.A.CONSTRUMAN S.A. UTEAUTOTROL S.A.CONSTRUMAN S.A. UTENaN2017-10-27T00:00:00ZNaNVE42017-10-13T00:00:00Z-34.61781-58.50482NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros0.60.61.20.360.432AperturasNaNPLANLASCANO 4625ACERA0.0
7cancelled0.0regular4.0121471150020511111NaN2017-10-17T14:04:59ZMonte CastroEMC10NaN2017-10-27T00:00:00Z15AUTOTROL S.A.CONSTRUMAN S.A. UTEAUTOTROL S.A.CONSTRUMAN S.A. UTENaN2017-10-27T00:00:00ZNaNVE42017-10-13T00:00:00Z-34.61813-58.50542NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros0.65.00.63.001.800AperturasNaNPLANLASCANO 4695ACERA0.0
8complete18.0regular4.08823150019832130NaNNaNRecoletaEMC02NaN2017-08-12T00:00:00Z3RADIOTRONICA DE ARGENTINA SATELEF?NICA DE ARGENTINA SOCIEDAD ANA_DME2017-08-10T00:00:00ZNaNVE52017-08-08T00:00:00Z-34.58818-58.39861NaNNaNNaNNaNNaNNaNNaNNaN1.0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN1.01.21.01.201.200Rojas Natalia3.0SERVPUEYRREDON AV. 2030, CABAACERANaN
9cancelled0.0regular4.0121489150020511314NaN2017-10-17T14:05:00ZVilla LuroEMC10NaN2017-10-27T00:00:00Z15AUTOTROL S.A.CONSTRUMAN S.A. UTEAUTOTROL S.A.CONSTRUMAN S.A. UTENaN2017-10-27T00:00:00ZNaNVE42017-10-13T00:00:00Z-34.63273-58.50647NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros0.60.61.20.360.432AperturasNaNPLANHUGO, VICTOR 621ACERA0.0

Last rows

activity_statusactivitynumberactivitytypeactivitywotypeaidapptnumberatime_of_assignmentatime_of_bookingbarrioclase_avisocomunactime_delivered_enddateduracionempresa_contratistaempresa_solicitanteestado_generalfin_obragp_nuevogrupo_planificadorinicio_obralatitudelongitudemobileactacomprobamobileactaintimamobileactasecuestromobilec01mobilec02mobilec03mobilec06mobilec07mobilec08mobilec09mobilec10mobilec11mobilec12mobilec13mobilec14mobilec15mobilec16mobilec17mobilec18mobilec20mobilec21mobilec22mobilec23mobilec24mobilec25mobilec26mobilec27mobilec28mobilec29mobilec30mobilec31mobilec32mobilec33mobilec34mobiledesnivelmobileseveridadno_realizadoobra_anchoobra_largoobra_profundidadobra_superficie_m2obra_volumen_m3resource_nameseveridadstatus_usuariostreetaddresstipo_obratraveltime
1078339completeNaNregularNaN13509261900024787102019-05-16T11:58:01Z2019-05-15T21:13:36ZPalermoCGC14NaN2019-05-17T00:00:00Z7EMA SERVICIOS S.A.AGUA Y SANEAMIENTOS ARGENTINOS SOCIAC_NEA2019-05-22T00:00:00ZNaNVE42019-05-16T00:00:00Z-34.58777-58.41830NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.60.60.600.360.216JTOURNIERNaNINEXARAOZ 2267ACERA7.0
1078340completeNaNregularNaN12733591400105690102019-05-16T12:13:56Z2019-04-16T12:04:13ZPalermoAPC14NaN2019-05-17T00:00:00Z7IBERCOM MULTICOM S.ANSS S.A.A_DBE2018-12-14T00:00:00ZNaNVE62018-12-08T00:00:00Z-34.58815-58.41298NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0.42.00.800.800.640JTOURNIERNaNREOKVIDT 2098ACERA18.0
1078341suspendedNaNregularNaN13561641500254917112019-05-16T11:58:01Z2019-05-10T15:13:08ZPalermoEMC14NaN2019-05-17T00:00:00Z15AGUA Y SANEAMIENTOS ARGENTINOS SOCIAGUA Y SANEAMIENTOS ARGENTINOS SOCINaN2019-05-24T00:00:00ZNaNVE42019-05-10T00:00:00Z-34.59590-58.42141NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros1.00.60.400.600.240JTOURNIERNaNPLANACUÑA DE FIGUEROA, FRANCISCO 1388ACERA0.0
1078342suspendedNaNregularNaN13561651400106928302019-05-16T12:13:56Z2019-04-08T06:56:45ZPalermoAPC14NaN2019-05-17T00:00:00Z30LUBRISIDER S.A.EDENOR SANaN2018-12-18T00:00:00ZNaNVE52018-11-19T00:00:00Z-34.59708-58.42165NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros0.413.01.105.205.720JTOURNIERNaNPLANACUÑA DE FIGUEROA, FRANCISCO 1264ACERA1.0
1078343suspendedNaNregularNaN13561661500247815302019-05-16T12:13:56Z2019-02-28T12:03:00ZPalermoEMC14NaN2019-05-17T00:00:00Z15ZUBDESA S.AAGUA Y SANEAMIENTOS ARGENTINOS SOCINaN2019-02-22T00:00:00ZNaNVE72019-02-08T00:00:00Z-34.59705-58.42326NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros1.01.01.001.001.000JTOURNIERNaNPLANGASCON 1192ACERA1.0
1078344suspendedNaNregularNaN13561671900024288202019-05-16T11:58:01Z2019-05-06T08:19:02ZPalermoCGC14NaN2019-05-17T00:00:00Z15ZUBDESA S.AAGUA Y SANEAMIENTOS ARGENTINOS SOCINaN2019-05-17T00:00:00ZNaNVE42019-05-03T00:00:00Z-34.59596-58.41987NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros1.01.01.001.001.000JTOURNIERNaNPLANMEDRANO 1131ACERA0.0
1078345suspendedNaNregularNaN13561681400107432202019-05-16T12:13:56Z2019-03-12T18:03:20ZPalermoAPC14NaN2019-05-17T00:00:00Z16DOMINION INDUSTRY ARGENTINA S.ATELEFONICA DE ARGENTINA S.A.NaN2018-12-23T00:00:00ZNaNVE72018-12-08T00:00:00Z-34.59653-58.41935NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros0.4100.00.7040.0028.000JTOURNIERNaNPLANCABRERA, JOSE A. 3701ACERA0.0
1078346suspendedNaNregularNaN13561691400113967202019-05-16T11:58:01Z2019-04-26T21:42:17ZPalermoAPC14NaN2019-05-17T00:00:00Z22RETESAR S.A.TELEFONICA DE ARGENTINA S.A.NaN2019-05-18T00:00:00ZNaNVE42019-04-27T00:00:00Z-34.59653-58.41935NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros0.4100.00.7040.0028.000JTOURNIERNaNPLANCABRERA, JOSE A. 3799ACERA0.0
1078347suspendedNaNregularNaN13561701500246843102019-05-16T12:13:56Z2019-03-06T15:01:53ZPalermoEMC14NaN2019-05-17T00:00:00Z28EDENOR SAEDENOR SANaN2019-02-26T00:00:00ZNaNVE72019-01-30T00:00:00Z-34.59379-58.42322NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros0.410.00.654.002.600JTOURNIERNaNPLANHONDURAS 4270ACERA0.0
1078348suspendedNaNregularNaN13561711400106468802019-05-16T12:13:56Z2019-04-16T12:04:12ZPalermoAPC14NaN2019-05-17T00:00:00Z30SUPPLY SOUTH SRLEDENOR SANaN2018-12-05T00:00:00ZNaNVE62018-11-06T00:00:00Z-34.59545-58.41916NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNotros0.460.00.6524.0015.600JTOURNIERNaNPLANGORRITI 3835ACERA0.0